USE [db]
GO
/****** 对象:  UserDefinedFunction [dbo].[fn_GetStatus2]    脚本日期: 11/09/2015 10:26:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create function [dbo].[fn_GetStatus2](@field varchar(10))
returns int
as
begin
	declare @retval int
	if @field = '未取'
		set @retval = 0
	else
		set @retval = 1

	return @retval
end